﻿
using System.Data.Common;
using System.Data.OracleClient;
using System.Data;

namespace NetBay.Core.DataAccess
{
    public static class DbCommandEx
    {

        /// <summary>
        /// Add oracle result parmeter to the command
        /// </summary>
        /// <param name="dbCommand"></param>
        public static void AddOracleResultParameter(this DbCommand dbCommand)
        {
            var l_oOracleOutputParameter = new OracleParameter("O_Results", OracleType.Cursor);
            l_oOracleOutputParameter.Direction = ParameterDirection.Output;
            dbCommand.Parameters.Add(l_oOracleOutputParameter);
        }

    }
}
